70 Computer Literacy Certification
Computer Literacy Certification spreadsheet and data · type time limit to certification practical course with.
0. Purpose and ultimate goal
Computer Literacy Certification education of objective learners Korea Chamber of Commerce Computer Literacy Certification 1 · 2 of and assignment understanding and, Microsoft Excel and Microsoft Access time limit to using result. certification and online of core, CBT, Excel function · · with · Access query practice, · type mock exam operation using practical focused with operation.
Referenced professional training patterns
- Computer Literacy Certification 1 · 2 course of core, CBT, error note
- Excel course of function, conditional formatting, pivot table, chart, with, data analysis tools
- Access course of, query, form, report, relationship settings, SQL basic type
- Certification of hoursmanagement,, problem, practical mock exam based management
Introductory · 1 Day
Introductory 1 day Computer Literacy Certification curriculum
Computer Literacy Certification of core type step-by-step practice and assessment with complete.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Basic and by difference understanding. | CBT problem with core organization and classify. 1 and 2, exam time, passing criteria, submission method. |
| Objective 2 | Basic Excel type. | SUM, IF, COUNTIF, VLOOKUP/XLOOKUP, INDEX/MATCH, RANK, · function type data with. Conditional formatting, advanced filter, subtotal, pivot table, chart, goal seek time limit with complete. |
| Objective 3 | Basic Access and SQL basic. | , field, primary key, relationship, · · with tab query, form, report practice. SQL SELECT, WHERE, GROUP BY, ORDER BY query and connect. |
| Platforms | Microsoft Excel 2021/365, Microsoft Access 2021/365, Korea Chamber of Commerce CBT, Windows 11, Notion/Google Sheets managementtable |
|---|---|
| Instructor profile | Computer Literacy Certification 1 · 2, Excel function · · with, Access query · form · report, mock exam map experience |
| Target learners | Computer Literacy Certification exam application, job seeker, introductory, vocational trainee, college student |
| Duration | 4-6 hours |
| Materials | PC or, Microsoft Office Professional, CBT problem, past exam question file,, error note |
| Deliverables | Computer Literacy Certification basic practicefile, individual, mock exam resulttable, learning |
| Assessment method | Understanding 25%, practicecompletion 35%, assessment 25%, 10%, participation 5% |
Beginner · 3 Days
Beginner 3 days Computer Literacy Certification curriculum
Computer Literacy Certification of core type step-by-step practice and assessment with complete.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Core and by difference understanding. | CBT problem with core organization and classify. 1 and 2, exam time, passing criteria, submission method. |
| Objective 2 | Core Excel type. | SUM, IF, COUNTIF, VLOOKUP/XLOOKUP, INDEX/MATCH, RANK, · function type data with. Conditional formatting, advanced filter, subtotal, pivot table, chart, goal seek time limit with complete. |
| Objective 3 | Core Access and SQL basic. | , field, primary key, relationship, · · with tab query, form, report practice. SQL SELECT, WHERE, GROUP BY, ORDER BY query and connect. |
| Platforms | Microsoft Excel 2021/365, Microsoft Access 2021/365, Korea Chamber of Commerce CBT, Windows 11, Notion/Google Sheets managementtable |
|---|---|
| Instructor profile | Computer Literacy Certification 1 · 2, Excel function · · with, Access query · form · report, mock exam map experience |
| Target learners | Computer Literacy Certification exam application, job seeker, introductory, vocational trainee, college student |
| Duration | 12-18 hours |
| Materials | PC or, Microsoft Office Professional, CBT problem, past exam question file,, error note |
| Deliverables | Computer Literacy Certification core practicefile, individual, mock exam resulttable, learning |
| Assessment method | Understanding 25%, practicecompletion 35%, assessment 25%, 10%, participation 5% |
Beginner · 1 Week
Beginner 1 week Computer Literacy Certification curriculum
Computer Literacy Certification of core type step-by-step practice and assessment with complete.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Practical and by difference understanding. | CBT problem with core organization and classify. 1 and 2, exam time, passing criteria, submission method. |
| Objective 2 | Practical Excel type. | SUM, IF, COUNTIF, VLOOKUP/XLOOKUP, INDEX/MATCH, RANK, · function type data with. Conditional formatting, advanced filter, subtotal, pivot table, chart, goal seek time limit with complete. |
| Objective 3 | Practical Access and SQL basic. | , field, primary key, relationship, · · with tab query, form, report practice. SQL SELECT, WHERE, GROUP BY, ORDER BY query and connect. |
| Platforms | Microsoft Excel 2021/365, Microsoft Access 2021/365, Korea Chamber of Commerce CBT, Windows 11, Notion/Google Sheets managementtable |
|---|---|
| Instructor profile | Computer Literacy Certification 1 · 2, Excel function · · with, Access query · form · report, mock exam map experience |
| Target learners | Computer Literacy Certification exam application, job seeker, introductory, vocational trainee, college student |
| Duration | 20-30 hours |
| Materials | PC or, Microsoft Office Professional, CBT problem, past exam question file,, error note |
| Deliverables | Computer Literacy Certification practical practicefile, individual, mock exam resulttable, learning |
| Assessment method | Understanding 25%, practicecompletion 35%, assessment 25%, 10%, participation 5% |
Intermediate · 4 Weeks
Intermediate 4 weeks Computer Literacy Certification curriculum
Computer Literacy Certification of core type step-by-step practice and assessment with complete.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Type and by difference understanding. | CBT problem with core organization and classify. 1 and 2, exam time, passing criteria, submission method. |
| Objective 2 | Type Excel type. | SUM, IF, COUNTIF, VLOOKUP/XLOOKUP, INDEX/MATCH, RANK, · function type data with. Conditional formatting, advanced filter, subtotal, pivot table, chart, goal seek time limit with complete. |
| Objective 3 | Type Access and SQL basic. | , field, primary key, relationship, · · with tab query, form, report practice. SQL SELECT, WHERE, GROUP BY, ORDER BY query and connect. |
| Platforms | Microsoft Excel 2021/365, Microsoft Access 2021/365, Korea Chamber of Commerce CBT, Windows 11, Notion/Google Sheets managementtable |
|---|---|
| Instructor profile | Computer Literacy Certification 1 · 2, Excel function · · with, Access query · form · report, mock exam map experience |
| Target learners | Computer Literacy Certification exam application, job seeker, introductory, vocational trainee, college student |
| Duration | 40-60 hours |
| Materials | PC or, Microsoft Office Professional, CBT problem, past exam question file,, error note |
| Deliverables | Computer Literacy Certification · type practicefile, individual, mock exam resulttable, learning |
| Assessment method | Response 30%, practicalcompletion 30%, feedbackimprovement 20%, operationdocument 15%, presentation 5% |
Advanced · 8 Weeks
Advanced 8 weeks Computer Literacy Certification curriculum
Computer Literacy Certification of core type step-by-step practice and assessment with complete.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Instructor type · operation and by difference understanding. | CBT problem with core organization and classify. 1 and 2, exam time, passing criteria, submission method. |
| Objective 2 | Instructor type · operation Excel type. | SUM, IF, COUNTIF, VLOOKUP/XLOOKUP, INDEX/MATCH, RANK, · function type data with. Conditional formatting, advanced filter, subtotal, pivot table, chart, goal seek time limit with complete. |
| Objective 3 | Instructor type · operation Access and SQL basic. | , field, primary key, relationship, · · with tab query, form, report practice. SQL SELECT, WHERE, GROUP BY, ORDER BY query and connect. |
| Platforms | Microsoft Excel 2021/365, Microsoft Access 2021/365, Korea Chamber of Commerce CBT, Windows 11, Notion/Google Sheets managementtable |
|---|---|
| Instructor profile | Computer Literacy Certification 1 · 2, Excel function · · with, Access query · form · report, mock exam map experience |
| Target learners | Computer Literacy Certification exam application, job seeker, introductory, vocational trainee, college student |
| Duration | 80-120 hours |
| Materials | PC or, Microsoft Office Professional, CBT problem, past exam question file,, error note |
| Deliverables | Computer Literacy Certification instructor lesson guide, type problem, assessment rubric, organization operation manual |
| Assessment method | Response 30%, practicalcompletion 30%, feedbackimprovement 20%, operationdocument 15%, presentation 5% |